Shareware Grab Bag

home *** CD-ROM | disk | FTP | other *** search

/ Shareware Grab Bag / Shareware Grab Bag.iso / 006 / javlrn2.arc / WORKSHT2.CAS (.txt) < prev

Wrap

Javelin Case Study | 1985-10-01 | 44.7 KB | 1,146 lines

worksht2 ~0Copyright (c) 1985 Javelin Software Corporation. S/N 0412345679 Press [F1] for Help. Version E4.69 Diagram view Table view READY &MORE ON THE JAVELIN WORKSHEET $This case study shows you more features of Javelin's Worksheet view. This case study is a continuation of the one called } %The Javelin Worksheet} $- Press [Space] to continue - $- or press [F1] for Help - 228K ~%In this case study, you'll see how to ~&enter and copy formulas on worksheets. ~$You will also see how to use two or more worksheets} $ to look at the same information in different ways. %Example~ : Chisel & Gouge Furniture Co. ~& Chisel & Gouge Furniture Co. builds ~"desks, dressers, and tables at two locations: Omaha and Topeka. ~" Use Javelin worksheets to create ~#reports examining the production of each item at each location. ~#Chisel & Gouge's production data is $stored in a file called GOUGE. To load this file, type: & $/' $F' $L' $} 'gouge DEFINE } CLEAR WINDOW PRINT MENU ~MDefine variable, building block, worksheet, graph, macro, time pd., settings. Delete Import ... Save Load FILE Load a model file from disk. m view READY ~ Filename: WAIT ~ gouge.mdl C&G Production -}?-Jan 1986 Feb 1986 Mar 1986 Apr 1986 May 1986 Jun 1986 Jul 1986 -Omaha - Desks - Dressers - Tables -Topeka - Desks - Dressers - Tables Formulas for all variables: Topeka Tables = Monthly data: Januar Topeka Dressers = Monthly data: Janu Topeka Desks = Monthly data: January Omaha Tables = Monthly data: January Omaha Dressers = Monthly data: Janua Omaha Desks = Monthly data: January READY ~ gouge.mdl loaded. ~%The worksheet in the top window shows ~#how many of each item were produced at each location. &Entering a Formula ~&All of the variables on this worksheet %input variables~ -- that is, they }%$are defined by data, not by formulas. ~%Worksheets can show variables defined by formulas, too. Let's crea} $te a new variable called %Omaha Total~ . This will be the sum of all items produced in Omaha. ~ Move the cursor to the row below Omaha Tables. Press: Omaha Desks ressers Tables ~"To enter a formula in a worksheet: }%$1. Enter a variable name in a border. ~$2. Enter an expression in one of the ~" variable's cells in the body of the worksheet. }%$This creates a formula by setting the ~!variable equal to the expression. ~%Follow these steps to enter a formula for Omaha Total. ~"First, type two spaces, then enter %Total~ in the left border: '[Space] '[Space] 'Total Total WAIT READY Total ~!Now move the cursor to the right: Omaha Total: ~"In this cell, we want to enter the following expression: %Omaha Desks + %Omaha Dressers + Omaha Tables~ ~"This expression will calculate the value of Omaha Total. &Using the POINT Key }"$Rather then type in the expression ~%for Omaha Total directly, you can use ~%the POINT key, [F4], to point to each variable with the curs} ~&Press the POINT key to begin pointing: '[F4] Omaha Total: POINT Omaha Total When you} $ press $key, the ~%variable at the cursor appears on the ~#edit line at the top of the screen. ~#Watch the edit line as you move the cursor to } %Omaha Desks~ , the first ~"variable in the expression. Press: Omaha Tables Omaha Dressers Omaha Desks ~"As you move the cursor to point to ~ Omaha Desks, Javelin copies each variable name to the edit line. ~!Now type a plus sign and move the $point to the next variable, Omaha Dressers: Omaha Dressers ~ Typing a plus sign (or any other ~%operator) selects the variable at the ~!cursor. You can then point to the next variable you want in the expression. ~!The POINT indicator on the status ~!line reminds you that you are sti } $pointing. ~%o finish the expression, type another ~%plus sign and point to Omaha Tables: & $+' $ Omaha Tables ~$Now that the expression is complete, ~!press to enter the expression and stop pointing: READY #CALC #CALC #CALC #CALC #CALC #CALC #CALC WAIT ~&Topeka Tables = Monthly data: Januar Dressers = Monthly data: Janu esks = Monthly data: January ~&Omaha Total = Omaha Desks+Omaha Dresse READY ~4Omaha Total: Omaha Desks+Omaha Dressers+Omaha Tables ~ Look at the Formulas view in the ~"bottom window. You can see part of $the formula for Omaha Total. ~$You created this formula by entering ~$an expression for Omaha Total in the body of the worksheet. ~"The information line at the top of ~$the screen shows you how the formula appears in the worksheet. see the variable you defined, ~$Omaha Total, followed by a colon (:) ~#and the expression that defines it. ~!#CALCs in the worksheet mean that ~ variable is not yet calculated. ~!To calculate the model, press the ~ CALC key: '[F9] WAIT 409 401 402 400 414 409 401 READY ~#Javelin calculates values for Omaha ~&Total and shows them in the worksheet. ~%he formula you entered applies to the } %whole row~ for Omaha Total, not just ~%to one cell. The formula computes the }%$variable's value for all dates in the model. &Copying Formulas ~&Instead of typing in a new formula for ~$Topeka Total, we'll copy the formula for Omaha Total. ~!First, show this worksheet in one window. Type: & $/' $W' $1' DEFINE CLEAR WINDOW PRINT FILE *WORKSHEET MENU ~)Load, save, import, or delete disk files. Adjust Switch 2 windows 1 window WINDOW Show only one window. -Feb 1986 Mar 1986 C&G Production READY ~4Omaha Total: Omaha Desks+Omaha Dressers+Omaha Tables To copy bot} $h the variable name and ~$the formula for a variable, you must ~$copy the border cell and a cell that contains the expression. ~$For example, to copy the formula for ~!Omaha Total, you must copy the ce ~"that contains the word Total and a worksheet cell in that row. ~"First, move the cursor to the left border by pressing: Total ~%Then use the *Worksheet Copy command: & $/' $*' $C' DEFINE CLEAR WINDOW } PRINT *WORKSHEET MENU Set up or change windows. Name change Import file .. Range ... Border ... Data copy Copy *WORKSHEET Copy contents of cells. -986 Jun 1986 Jul 1 C&G Production READY POINT ~FSpecify range to copy from: move to corner of range and press . or ~"At the top of the screen, the Copy ~"command prompts you to specify the range to copy from. }%$To specify the range, first anchor it ~ by typing a period (.) in the ce ~!where the range will begin. Type: ~8Press arrows to show range, then press to select it. ~#Now expand the range to include the ell to the right: ~%The cursor spreads over both cells in ~$the range you are copying. To finish specifying the range, press: READY POINT ~DSpecify range to copy to: move to corner of range and press . or You specified the range to copy %from~ ~%Javelin prompts you at the top of the $screen to enter a range to copy $t%o%~ ~%Move the cursor to the row just under Topeka Tables: '[End] ~)End: Press arrow key to select direction. WAIT POINT ~DSpecify range to copy to: move to corner of range and press . or Now watch the worksheet as you complete the command. Press: READY WAIT Total #CALC #CALC READY Total ~"The Copy command copies the border ~!cell and the expression for Omaha ~#Total to the last row under Topeka. ~"Calculate values for Topeka Total: '[F9] WAIT 494 497 READY The values for Topeka Total are ~%the same as those for Omaha Total. To ~"see why, move the cursor to one of ~"the cells for Topeka Total. Press: '[End] ~)End: Press arrow key to select direction. WAIT READY Total ~8Topeka Total: Topeka Desks+Topeka Dressers+Topeka Tables ~#Look at the information line at the ~#top of the screen. Topeka Total has } $the same formula as Omaha Total, except that all instances of %Omaha are replaced by } %Topeka~ ~#To make the formula correct for the ~"new context under Topeka, Javelin ~%changed Omaha to Topeka everywhere in $the formula. This is one example of how the *Worksheet Copy command works. Any time you cop} $y calculated values ~ to a new context in a worksheet, ~!Javelin creates formulas that are ~!appropriate for the new context. &Using Multiple Worksheets ~&The worksheet on your screen shows one ~ way to look at monthly furniture production. ~%By creating another worksheet, we can ~"look at the same formulas and data from a different perspective. ~%Because data is stored in the central base of} $ information -- and not in any ~!particular worksheet -- different ~"worksheets can show the same data. ~"Let's create a second worksheet to ~$show production figures. First split the screen into two windows: $ $ & $/' $W' $2' DEFINE CLEAR WINDOW PRINT *WORKSHEET MENU ~"Commands specific to current view. Adjust Switch 2 windows 1 window WINDOW Show only one window. a second -Feb 1986 Mar 1986 C&G Production READY Dressers Tables Total Topeka Desks Dressers Tables Total C&G P -Jan 1986 Feb 1986 Mar 1 Omaha Desks Dressers Tables Total Topeka Desks ~%Now switch to the top window and use the View Worksheet comm to create a worksheet called } %Items~ '[F6] & $/' $V' $W' $} 'Items ~8Topeka Total: Topeka Desks+Topeka Dressers+Topeka Tables DEFINE CLEAR WINDOW } PRINT *WORKSHEET MENU Set up or change windows. Graph Macro Errors Notes Worksheet Quick graph Chart Table Formulas ... Diagram VIEW Show diagram in current window. ~#Show a worksheet in current window. -an 1986 Feb 1986 M -an 1986 Feb 1986 M C&G Production ~ Worksheet name (C&G Production): READY Items WAIT READY ~"Javelin creates an empty worksheet called Items. ~$Each cell in the bottom worksheet is identified by three items: The city name in the left border. The item of furniture, indented $ beneath the city name. The date in the top border. ~%The new worksheet will use these same ~#three items, organized differently. ~#In the new worksheet, we'll put the city names and dates in the top ~%border, and the items of furniture in the left border. ~"The worksheet in the bottom window ~&shows how to get two names in the left ~#border: indent one under the other. top border, instead of ~!indenting, you can enter names or ~%dates one above the other. To do so, follow these steps: ~%1. Expand the top border to two rows. 2. Enter a heading in each row. roduction ~$First, expand the top border. Type: & $/' $*' $B' $E' DEFINE CLEAR WINDOW PRINT *WORKSHEET MENU ~"Commands specific to current view. Format Sort ... Exception Name change Import file .. Range ... Border ... Data copy Copy *WORKSHEET ~" Change width of current column. Shrink border Expand border Remove border Insert border Variable names Dates Border ... Enter dates in current border. Add a row to a top border. Format Sort ... Exception Name change Import file Range ... Border ... Data copy Copy Items READY ~#The top border expands to two rows. ~#Now you can enter cities in the top row, and dates beneath them. To begin, enter Omaha as the heading for the first column. Type: 'Omaha Omaha Omaha Then enter a date below it: 'Jan86 Jan 1986 Jan 1986 ~"To see the value of Omaha Desks in January, enter } %Desks~ in the left border. Type: 'Desks Desks Desks ~%Now watch the information line as you move the cursor to the number $9%7%~ Omaha Desks @ January 1986: 97 At the top of the screen, the information lin} $e shows } %Omaha Desks %@ January 1986: 97~ }!$Javelin combines the following to ~$determine what to show in this cell: %Omaha~ , from the top border. %Jan 1986~ , also from the top border. %Desks~ , from the left border. ~"Let's see some more data. Move the cursor to the left bord} $er and enter Dressers} $ below Desks: 'Dressers Dressers Dressers ~!Javelin shows the value for Omaha ~"Dressers. Now press [Space] and I' ~$fill in the rest of the left border. Tables Total Total ~4Omaha Total: Omaha Desks+Omaha Dressers+Omaha Tables ~)End: Press arrow key to select direction. WAIT READY ~%Javelin shows the values for the rest }!$of the Omaha variables in January 1986. }%$Now let's show the values for Topeka. Type Topeka in the top border: 'Topeka #NODATE #NODATE #NODATE #NODATE Topeka Topeka ~%You see the non-numeric value #NODATE ~#in place of the Topeka values. This ~%means that you have not yet specified ~ the date for which you want to s values of these variables. ~&You could specify the date by entering ~&January 1986 in the cell below Topeka. }#$You could also extend the date from the first column to the second. ~!Instead of repeating a top border ~&cell, you can just enter a hyphen (-). ~&The hyphen tells Javelin to extend the ext from a cell to the left. For example, to extend %Jan 1986~ acro ~!the second column (under Topeka), type: ' $-' $ Jan 1986 Javelin extends the heading %Jan 1986 ~#over both columns. Now both columns show values for January 1986. ~#Notice that the two worksheets show ~$he same data, but in different ways. ~$Let's recap what you've done so far: You created formulas on a} $ worksheet using the POINT key, [F4]. You used the *Worksheet Copy command ~% to copy a formula to a new context. You built a second worksheet to show the same data. &Using the Corner of a Worksheet ~&So far you've seen how to use headings ~ in the left and the top borders. ~ You can also use headings in the ~#corner of a worksheet. A heading in ~$the corner cell affects all cells in the worksheet. Firs} $t, let's put the Items worksheet in one window. Type: $ $ & $/' $W' $1' DEFINE CLEAR WINDOW PRINT *WORKSHEET MENU ~"Commands specific to current view. Adjust Switch 2 windows 1 window WINDOW Show a second window. only one -Topeka Items READY Jan 1986 ~%Now change this worksheet so that the ~#date January 1986 is in the corner, instead of in the top border. ~%The first step is to remove the dates $from the top border. Use the ~#*Worksheet Border Shrink command to ~&shrink the top border down to one row. Type: & $/' $*' $B' $S' DEFINE CLEAR WINDOW } PRINT *WORKSHEET MENU Set up or change windows. Format Sort ... Exception Name change Import file .. Range ... Border ... Data copy Copy *WORKSHEET ~JInsert, remove, expand, shrink, enter dates or variable names in a border. Shrink border Expand border Remove border Insert border Variable names Dates Border ... Add a row to a top border. Remove a row from a top border. Format Sort ... Exception Name change Import file Range ... Border ... Data copy Copy Items READY Desks #NODATE #NODATE ressers #NODATE #NODATE Tables #NODATE #NODATE #NODATE #NODATE Topeka Desks: Monthly data. The Border Shrink command is the reverse of the Border Expand command ~% you used earlier. It shrinks the top border to one row, deleting that had the dates. ~"With the dates gone, the worksheet ~"shows #NODATE everywhere. You must ~$specify a date for all the values in $the worksheet. ~"Enter the date in the corner cell. ~ Watch the worksheet as you type: '[Home] 'Jan86 Jan 1986 Jan 1986 ~#The corner cell affects every value in the worksheet. You see a %snapshot ~$of the model at a single date -- the worksheet shows the values of a ~$variables at a single point in time. ~%If you change the date, the worksheet ~$shows values for the new date. Type: 'Feb86 Feb 1986 ~%Now the worksheet shows the values of all variables in February 1986. ~&You can also type a yearly date in the corner. ~&Since worksheets automatically convert }#$values to any date, simply entering 1986 in the corner causes the ~%worksheet to show 1986 totals. Type: '1986 ~&Javelin adds up the monthly production ~ values, and shows you total 1986 production. So far, you've seen how to names ~!and dates in the left border, top ~$border, and corner of the worksheet. ~&In the next section, you'll see how to }#$enter labels that do not affect the values shown in a worksheet. &Labels A$ $} %label~ is text you add to a ~$worksheet. Unlike the variable names ~$in the borders, labels do not affect ~#the numbers shown in the worksheet. ~&You can use labels to add comments or ~#titles without changing the numbers ~%and variables shown on the worksheet. ~%For example, suppose you want the top $left corner to show $} %86 Totals~ instead o$f$ $} %1986~ ~!If you just typed the text in the ~$cell, Javelin would try to interpret ~%the text as part of a variable name. ~!To indicate that you are typing a ~#label, and not a variable name or a date, you type a } %label-prefix~ }$$front of the label. The label-prefix can be any of the following: '$ $ $} %apostrophe~ : left-justified label "$ $ $} %double quote~ : right-justified label ^$ $ $} %caret~ : centered label \$ $ $} %backslash~ : repeating label ~"For example, to put a label in the ~!top left corner cell, first press the EDIT key: '[F2] ~%This puts the contents of the cell on ~%the edit line. Add a label by typing: '[End] ''86 Totals ~ 86 Totals 1986'86 Totals ~"The numbers do not change when you ~"enter the label. The label affects ~"only what is shown in the top left cell. ~"The label hides the date 1986. The date is still there, however, ~%controlling the values you see in the rest of the worksheet. &Inserting Borders ~&Another way to control what you see on ~&a worksheet is to divide the worksheet ~#into separate regions by adding new sets of borders. ~%For example, suppose you want to show ~$both the January 1986 values and the 1986 totals. ~&You could show the January 1986 values ~#in a second worksheet, or you could ~"change the headings in the current worksheet. ~"You could also add a second set of ~!borders to the current worksheet. an insert a new set of borders anywhere on the worksheet. ~$For this example, move the cursor to ~$the cell just below the names in the left border. Press: '[End] ~)End: Press arrow key to select direction. WAIT READY 1986'86 Totals Total ~%Now create a new set of borders using ~%the *Worksheet Border Insert command. Type: & $/' $*' $B' $I' DEFINE CLEAR WINDOW PRINT *WORKSHEET MENU ~"Commands specific to current view. Name change Import file .. Range ... Border ... Data copy Copy *WORKSHEET ~JInsert, remove, expand, shrink, enter dates or variable names in a border. Remove border Insert border Variable names Dates Border ... Remove a row from a top border. ~#Insert a new border into worksheet. Name change Import file Range ... Border ... Data copy Copy Items READY WAIT READY ~$Javelin inserts a new set of borders ~!at the cursor. The new horizontal ~%border separates the 1986 totals from the rest of the worksheet. ~#The new set of borders controls the cells below it. ~"The next step is to put the cities }!$and items of furniture in the new borders. Press [Space] and I'll use the ~#*Worksheet Copy command to copy the ~"names from the top set of borders. 1986'86 Totals Desks DEFINE CLEAR WINDOW PRINT *WORKSHEET MENU ~"Commands specific to current view. Name change Import file .. Range ... Border ... Data copy Copy *WORKSHEET ~JInsert, remove, expand, shrink, enter dates or variable names in a border. Copy contents of cells. Items READY POINT ~FSpecify range to copy from: move to corner of range and press . or ~8Press arrows to show range, then press to select it. READY POINT ~DSpecify range to copy to: move to corner of range and press . or ~)End: Press arrow key to select direction. WAIT POINT ~DSpecify range to copy to: move to corner of range and press . or READY WAIT Desks Dressers Tables Total READY Desks ~"Omaha Desks @ 1986: Monthly data. DEFINE CLEAR WINDOW PRINT *WORKSHEET MENU ~"Commands specific to current view. Name change Import file .. Range ... Border ... Data copy Copy *WORKSHEET Copy contents of cells. Items READY POINT ~FSpecify range to copy from: move to corner of range and press . or ~8Press arrows to show range, then press to select it. READY POINT ~DSpecify range to copy to: move to corner of range and press . or ~)End: Press arrow key to select direction. WAIT POINT ~DSpecify range to copy to: move to corner of range and press . or READY WAIT Omaha Topeka #NODATE #NODATE #NODATE #NODATE #NODATE #NODATE #NODATE #NODATE READY Omaha ~)End: Press arrow key to select direction. WAIT READY Omaha cursor is in the corner of the ~"new set of borders. Since you have not yet entered a date, you s #NODATE in place of all values. Now enter the date %January 1986~ in the ~!corner of the new set of borders. Type: 'Jan86 Jan 1986 Jan 1986 ~#You see the January 1986 values for all the variables. The date you entered in the corner affects everything in the lower set of borders. ~#With extra sets of borders, you can ~"divide your worksheet into as many ~"separate regions as you want. Each }&$region behaves like its own worksheet. &Exception Cells ~$Ordinarily, Javelin uses the borders ~$to determine what to show in a cell. %Exception cells~ break this rule. When ~$you create an exception cell, you te Javelin to show something } %other than what the borders indicate. There are two ways to create an ~ exception} $ cell: Enter a complete formula in a worksheet cell. The formula ~!becomes part of the model; the ce }!$ shows the variable you defined. Use the *Worksheet Excep} $tion command. ~%Let's create an exception cell at the bottom of the worksheet to show overall total production. ~#Move the cursor to a cell below the last row of values. Type: '[End] ~)End: Press arrow key to select direction. WAIT READY Jan 1986 Total Now enter the formula for Total ~%Production. When you enter a formula ~$in a worksheet cell, Javelin creates ~"an exception cell for the formula. Watch the top line as you type: 'Total Production= & $O'm'a' $} $T'o't' $} +' $T'o'p' $} $T'o't' $} WAIT READY WAIT Omaha Total Omaha Tables Omaha Dressers Omaha Desks POSSIBILITIES READY WAIT - Omaha -Tope 4866 2306 1531 1029 - Omaha -Tope READY WAIT READY WAIT READY WAIT Topeka Total Topeka Tables Topeka Dressers Topeka Desks POSSIBILITIES READY WAIT - Topeka - Topeka Items READY WAIT READY #CALC ~*Total Production: Omaha Total+Topeka Total ~$Javelin creates an exception cell at ~$the cursor. The exception cell shows ~##CALC. To calculate the model, pres the CALC key: '[F9] WAIT #NODATE READY ~%Now the exception cell shows the non- numeric value #NODATE. ~$By entering the formula, you created an exception cell to show Total ~ Production. However, you did not ~$specify for which date to show data. ~%The date in the corner of the borders ~%does not apply, since exception cells ignore worksheet borders. ~"To add a date to the definition of the exception cell, use the ~#*Worksheet Exception command. Type: & $/' $*' $E' DEFINE CLEAR WINDOW PRINT *WORKSHEET MENU ~"Commands specific to current view. Width Format Sort ... Exception Name change Import file .. Range ... Border ... Data copy Copy *WORKSHEET Copy contents of cells. ~!Create or edit an exception cell. Items READY Cell should show: Total Production The edit line shows the current definition of the exception cell: %Total Production} $, with no date specified. specify a date for an exception cell, add } %@ date~ at the end of the cell's definition. Type: '[End] $@' $} 'Jan86 ~*Total Production: Omaha Total+Topeka Total ~&Now the exception cell shows the value }$$of Total Production in January 1986. ~"As it stands now, the exception ce just looks like a number in the worksheet.} $ Let's enter a label to help identify it. ~%Move the cursor one cell to the left: ~!Now type a double quote ("), then ~"enter the label. (The double quote ~$right-justifies the label within the cell.) Type: '"TOTAL: TOTAL: "TOTAL: $Javelin shows the label right- ~ justified in the worksheet cell. ~%The label helps identify the value in ~ the exception cell as an overall total. &Summary In this case study, you: Entered and copied formulas in a worksheet. Looked at the same data in two worksheets. Used several methods to combine variable names and dates in the borders, including: $}%$ Indenting names in the left border. $}3$ Expanding the top border to include two headings. $}%$ Entering a date in the corner cell. Entered labels and exception cells. Related Case Studies: $ $}#%Importing Data into a Javelin Model~ shows you how to ~3import a Lotus 1-2-3 file into a worksheet, and how ~2 to import information from other Javelin models. $ $}$%Entering Data and Formatting Numbers~ shows several ~1ways to use numeric formats, including formatting numbers in worksheets. ~6If you want to learn more about using worksheets, read Chapter 12, } %Javelin Worksheets~ , in the Javelin ~0Reference Manual. Chapter 12 contains a complete ~3description of worksheet features with examples and suggestions for using them.